package org.compression.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.model.business.Magazine;

@Mapper
public interface AuthMapper {

	
	@Select("select m.path,m.coverpath from sm_auth_group ag,t_new_magazine m where ag.group_id in (select group_id from sm_usergroup where member_id=#{member_id}) and m.id=ag.book_id and m.id=#{magazine_id}")
	public Magazine getAuth(@Param("member_id")String member_id,@Param("magazine_id")String magazine_id);
	
	
	
	
}
